SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO
CREATE PROCEDURE [dbo].[paCertificaObtenerOrganismosEmisores]
-- < Registro de Actualizaciones >
-- 17-11-2006
-- 11-12-2006

AS
SET NOCOUNT ON
SET DATEFORMAT DMY
SELECT SO.IdSubOrganizacion AS ID, SO.Descripcion 
	FROM tb_SubOrganizaciones SO
	ORDER BY SO.Descripcion
GO
GRANT EXECUTE ON  [dbo].[paCertificaObtenerOrganismosEmisores] TO [Certificaciones]
GRANT EXECUTE ON  [dbo].[paCertificaObtenerOrganismosEmisores] TO [CertificacionesAdministracion]
GRANT EXECUTE ON  [dbo].[paCertificaObtenerOrganismosEmisores] TO [SoloVer]
GO
